package cn.edu.seig.textbook.mapper;

import cn.edu.seig.textbook.domain.pojo.Teachers;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author day
 * @since 2024-11-07
 */
@Mapper
public interface TeachersMapper extends BaseMapper<Teachers> {
    //根据教师姓名模糊查询教师
    @Select("SELECT * FROM tb_teachers WHERE name LIKE CONCAT('%', #{name}, '%')")
    List<Teachers> getTeachersByName(String name);

}
